How to: Create a worksheet template.
Solution:
Create a new workbook that contains the text, formats, and formulas to be included in the template, and save the workbook as a template.
1) Create a new, blank workbook to include the desired text, formats, and formulas:
a) Select the 'File' menu and select 'New...'. (The New dialog box appears.)
b) Select the 'Workbook' icon.
c) Click 'OK'. (A new, blank workbook appears.)
d) Type the desired text in the worksheet.
e) Apply the desired formats to the worksheet.
f) Type the desired formulas in the worksheet.
2) Save the workbook as a template:
a) Select the 'File' menu and select 'Save As...'. (The Save As dialog box appears.)
b) Select 'Template (*.XLT)' from the 'Save as type' drop-down list.
NOTE: In Office 95, all templates are saved to the Microsoft Office Templates folder.
c) Type a name for the template in the 'File name' drop-down list box.
d) Click 'Save'.
NOTE: When a template is used to create a new workbook, a copy of the template is used. The original remains unchanged.
